TG: oracle_dbd/922

Forwarded from Pavel V

Таблица customer_surveys содержит 2 млн строк.
Колонки:
a) age_group (группы по возрасту: 10-19, 20-29, ..., 60+); b) income_level (5 категорий); c) country_code (около 200 стран), survey_text (CLOB). Данные не обновляются. Какой индекс будет эффективен?

Anonymous Quiz

B-tree по income_level и country_code

Bitmap по income_level, country_code и age_group

Bitmap только по survey_text

Индекс не нужен, хватит full scan

187 answered

www.tg-me.com/ua/Oracle Developer‍/com.oracle_dbd/922

1.2K viewsMay 26 at 11:30

tg-me.com/oracle_dbd/922

Create: 2025-05-26
Last Update: 2025-07-02 02:46:17

BY Oracle Developer👨🏻‍💻

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/oracle_dbd/922

Oracle Developer‍ Telegram | DID YOU KNOW?

Unlimited members in Telegram group now

Telegram has made it easier for its users to communicate, as it has introduced a feature that allows more than 200,000 users in a group chat. However, if the users in a group chat move past 200,000, it changes into "Broadcast Group", but the feature comes with a restriction. Groups with close to 200k members can be converted to a Broadcast Group that allows unlimited members. Only admins can post in Broadcast Groups, but everyone can read along and participate in group Voice Chats," Telegram added.

How Does Telegram Make Money?

Telegram is a free app and runs on donations. According to a blog on the telegram: We believe in fast and secure messaging that is also 100% free. Pavel Durov, who shares our vision, supplied Telegram with a generous donation, so we have quite enough money for the time being. If Telegram runs out, we will introduce non-essential paid options to support the infrastructure and finance developer salaries. But making profits will never be an end-goal for Telegram.